<?php

/**
 * Maikuro Framework
 *
 * LICENSE:
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * The license is bundled with this package in the file LICENSE.txt.
 * You may also obtain a copy of the License at this URL:
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 * @copyright  Copyright (c) 2010, Jonathan Hedrén
 * @author     Jonathan Hedrén <jonathan.hedren@gmail.com>
 * @license    http://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0
 */

/**
 * @see IDbHandler
 */
require_once 'IDbHandler.php';

/**
 * @see DbResult
 */
require_once 'DbResult.php';

/**
 * @see PdoDbTransaction
 */
require_once 'PdoDbTransaction.php';

/**
 * Base class for PDO connections.
 */
abstract class AbstractPdoDbHandler implements IDbHandler
{
	
    /**
     * The database connection.
     *
     * @var mixed
     */
    protected $connection;

    /**
     * Creates a transaction.
     *
     * @return PdoDbTransaction
     */
    public function createTransaction()
    {
        return new PdoDbTransaction($this->connection);
    }

    /**
     * Queries the database. Caches the result if the query does not
     * contain an INSERT, UPDATE, REPLACE or SET clause.
     *
     * @param string $sql
     * @param array $values
     * @return DbResult
     */
    public function query($sql, array $values = array())
    {
        return $this->createTransaction()
                    ->addQuery($sql, $values)
                    ->commit();
    }
}
